Creating the Date Table 9

Creating a Date table:

Step 1To create date table go to data model, select new table as shown in the gif below then copy and paste the date table query provided in the doc (you will find a word document containing the DAX by clicking on the red icon on top). 

and then name it as Date, arrange to have a clear and legible DAX, then click on commit (the check mark) to create the date table.

Right click on the date table, select mark as date table then choose date from the drop down in the window and click on Ok button. After that click on date column then go to column tools - format -select 03/14/2001 (mm/dd/yyyy) as shown in the gif. 

Then select quarter column then go to top like above screenshot and click on sort by column then from the drop down list select quarter number, and do the same for remaining columns like,

sort by Quarter = Quarter Number

Month = Month Number

Week Day = Week Day Number

Year Month = Year Month Number

 Year Quarter = Year Quarter Number.

Follow the gif. 


Step 2. After you done that go to main menu and click on transform data and then select InterviewDate column in the IMock Interview Critique table then go to top as shown in the screenshot below, click on data type and select date in the drop down list to change the data type, then click on close and apply. Follow the gif below for more guidance.


After that in the data model click on the date table and right click on the Quarter Number and select Hide in report view, do the same for remaining columns like,

 Month Number, Week Day Number, Year Month Number, Year Quarter Number.

Then go to relationship view to make relationship between IMockInterviewCritique table and date table and then select InterviewDate column, drag and drop it in the date table with the date column to make many to one relationship like shown in the gif below.


Creating date table in Power BI

https://www.youtube.com/watch?v=F2V0IKp6hKM

Creating the Date Table 9

Creating a Date table:

Step 1To create date table go to data model, select new table as shown in the gif below then copy and paste the date table query provided in the doc (you will find a word document containing the DAX by clicking on the red icon on top). 

and then name it as Date, arrange to have a clear and legible DAX, then click on commit (the check mark) to create the date table.

Right click on the date table, select mark as date table then choose date from the drop down in the window and click on Ok button. After that click on date column then go to column tools - format -select 03/14/2001 (mm/dd/yyyy) as shown in the gif. 

Then select quarter column then go to top like above screenshot and click on sort by column then from the drop down list select quarter number, and do the same for remaining columns like,

sort by Quarter = Quarter Number

Month = Month Number

Week Day = Week Day Number

Year Month = Year Month Number

 Year Quarter = Year Quarter Number.

Follow the gif. 


Step 2. After you done that go to main menu and click on transform data and then select InterviewDate column in the IMock Interview Critique table then go to top as shown in the screenshot below, click on data type and select date in the drop down list to change the data type, then click on close and apply. Follow the gif below for more guidance.


After that in the data model click on the date table and right click on the Quarter Number and select Hide in report view, do the same for remaining columns like,

 Month Number, Week Day Number, Year Month Number, Year Quarter Number.

Then go to relationship view to make relationship between IMockInterviewCritique table and date table and then select InterviewDate column, drag and drop it in the date table with the date column to make many to one relationship like shown in the gif below.


Creating date table in Power BI

https://www.youtube.com/watch?v=F2V0IKp6hKM